WorkstationRuleApplication

Entity Definition

Logical Name : WorkstationRuleApplication
Physical Name : CO_APLN_WS_RU

An association indicating applicability of a WorkstationRule to a Workstation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
WorkstationRuleTypeCode (FK)(PK) A code that refers to a specific WORKSTATION RULE type. TY_RU_WS Code2 char(2) WorkstationRule(RU_WS)
WorkstationRuleNumber (FK)(PK) A reference number for a specific WORKSTATION RULE. ID_RU_WS Identity integer WorkstationRule(RU_WS)
WorkstationGroupID (FK)(PK) A unique identifier for a group of WORKSTATIONs. This could refer to the WORKSTATIONs at the checkout, delicatessen, customer service or in the goods receiving area of the store. ID_GP_WS Identity integer WorkstationRule(RU_WS)
EffectiveDate The date on which a specific WORKSTATION RULE becomes effective. DC_APLN_EF EffectiveDateTime datetime
ExpirationDate The date on which a specific WORKSTATION RULE expires. DC_APLN_EP ExpirationDateTime datetime
CreateDateTimestamp The time and date on which a specific WORKSTATION RULE is created. TS_APLN_CRT AuditDateTime datetime

Relationships

Parent Entity Verb Phrase Child Entity
Workstation is governed through WorkstationRuleApplication
WorkstationRule governs WorkstationRuleApplication
WorkstationRuleApplication is tracked by WorkstationRuleOverrideHistory

Logical Views containing WorkstationRuleApplication

Logical View
Logical 06210 - Access Control - Rules View
Logical 06220 - Access Control - Overrides View